﻿CREATE VIEW [acms].[UserSecurity_View]
AS 
	SELECT 
		[acms].[Users].[Id],
		[acms].[Users].[UserName],
		[acms].[Users].[Password],
		[acms].[Users].[Salt],
		[acms].[Users].[PasswordQuestion],
		[acms].[Users].[PasswordAnswer],
		[acms].[Users].[EmailAddress],
		[acms].[Users].[Authenticated],
		[acms].[Users].[Created],
		[acms].[Users].[Locked],
		[acms].[Users].[LastLogin],
		[acms].[Users].[LastActivity],
		[acms].[Users].[LastChangedPassword],
		[acms].[Users].[LastLocked],
		VersionId
	FROM [Users]
;